﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Model;
using System.Data;

namespace DALayer
{
    public class LongCarDAL
    {
        public static DataTable SelectLongCar(int LongID)
        {
            string sql = $"select *,BMMan=(select count(*) from ALTable where LongID=lo.LongID and ALStatus='已同意'),SQMan=(select count(*) from ALTable where LongID=lo.LongID) from LongCarShare lo where lo.LongID={LongID}";
            return DBHelper.SelectByAdapter(sql);

        }
    }
}
